<!--- begin dsp_all.cfm --->
#l#cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
#l#cfinclude template="qry.cfm" />
<cfoutput>
<cfif is_identity eq 'Y'>
#l#cfoutput>
	#l#a href="frm_modify.cfm?#column_name#=0" class="button">New #dspFormat(column_name)##l#/a>
#l#/cfoutput><br clear="all" />
</cfif>
</cfoutput>

#l#cf_dsp_results_nav rs="##rs_#tabName(Table_Name)###" recsPerPage="##attributes.recsPerPage##">
<table class="sortable report">
	<caption>
	#l#cfoutput> ##request.filter## #l#/cfoutput>
	</caption>
	<thead>
		<tr>
			<cfoutput><cfif is_identity eq 'Y'>#l#cfif isAdmin()><th sort="false">act</th>#l#/cfif><cfelse><th>#dspFormat(column_name)#</th></cfif>
			</cfoutput>
		</tr>
	</thead>
	<tbody>
		#l#cfoutput query="rs_#tabName(Table_Name)#" startRow="##request.StartRow##" maxRows="##request.MaxRows##">
			<tr>
				<cfoutput>
				<cfif is_identity eq 'Y'>
				#l#cfif isAdmin()>
				<td>
				<a href="../#tabName(Table_Name)#/frm_modify.cfm?#column_name#=##rs_#tabName(Table_Name)#.#column_name###" class="update icon" title="Update record">update record</a> 
				<a href="../#tabName(Table_Name)#/act_delete.cfm?#column_name#=##rs_#tabName(Table_Name)#.#column_name###" class="delete icon" title="Delete record" onClick="return confirmDelete();">delete record</a>
				</td>
				#l#/cfif>
				<cfelse>
				<td<cfif data_type CONTAINS "datetime"
						OR data_type CONTAINS "int"> class="numeric"</cfif>><cfif data_type CONTAINS "datetime">##LSDateFormat(rs_#tabName(Table_Name)#.#column_name#,request.dtFrmt)##<cfelse>##rs_#tabName(Table_Name)#.#column_name###</cfif></td>
				</cfif>
				</cfoutput>
			</tr>
		#l#/cfoutput>
	</tbody>
</table>
<!--- end dsp_all.cfm --->